package com.example.menuvirtualclient.dbschema;

public class TOrder_Detail {

	public static String CreateTable(){
		StringBuilder sb = new StringBuilder();
		sb.append("CREATE TABLE Orders_Details (");
		sb.append("id INTEGER PRIMARY KEY AUTOINCREMENT,");
		sb.append("orderid INTEGER,");
		sb.append("dishid INTEGER,");
		sb.append("date TIMESTAMP NOT NULL DEFAULT current_timestamp,");
		sb.append("status INTEGER,");
		sb.append("cookingPoint INTEGER);");
		
		return sb.toString();
	}
	
}
